UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jim2K/m0A/BbZzrj7wVYK/qnborKATO6QdIpTA69pOY='
WHERE
key_id = '9b1c29245c4335a911e9fa111a9d7fc7ae3c42cd4afe356bcebe0a6e1fbdf1c0'
AND (
token = 'Jim2K/m0A/BbZzrj7wVYK/qnborKATO6QdIpTA69pOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)