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