UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZvgTw/22ADk/ra4fmSypEIa07ubdqSGf+6fF5aUbj0='
WHERE
key_id = '0e18db9d09fa2dfd797f02081ce84ef76276b3a815d1276cb7ace049eb64a44b'
AND (
token = 'ZZvgTw/22ADk/ra4fmSypEIa07ubdqSGf+6fF5aUbj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)