UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E5rL88btTaVpIsU0CQn+EaPzmKQCSX20fdq+D0UwNDg='
WHERE
key_id = 'c3d91c0a9e90cb4705fa2f23bb4dc7c4310cb2727e64d1ea5124cd8f7754cd03'
AND (
token = 'E5rL88btTaVpIsU0CQn+EaPzmKQCSX20fdq+D0UwNDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)