UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1z9WBt7ubI7rD4ON/VwINbuj7v3lntX1jR9hRRhz72s='
WHERE
key_id = 'c2ab13ca5bed86829fca3e1e05bf53091b6c1faeb4a00627a41cb41fd27d0351'
AND (
token = '1z9WBt7ubI7rD4ON/VwINbuj7v3lntX1jR9hRRhz72s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)