UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hkCU9TwzqPwi7bWQMA5nuNHQrUJ80pv630iIW3I0MMU='
WHERE
key_id = 'd96c23a21c215c5b70dab04b4e6b4d8483a345e4fef51fa168ee1834973c6b72'
AND (
token = 'hkCU9TwzqPwi7bWQMA5nuNHQrUJ80pv630iIW3I0MMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)