UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZW1vslMphlzi6GWq3E/WGAmN12WF/nHa937KWkRijLg='
WHERE
key_id = '188f6a62f756c174848c50a6da35f4dd36ce5dd96f279d27d73828b5cdb63016'
AND (
token = 'ZW1vslMphlzi6GWq3E/WGAmN12WF/nHa937KWkRijLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)