UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TGBI5b3WGHR0WTldvD8TJ5pDDy/xNdf0k3i+wz42zGU='
WHERE
key_id = '45f5f5aca25283b7399dcec837b106dec51991a3be06198a6bbad3ebc7ead32a'
AND (
token = 'TGBI5b3WGHR0WTldvD8TJ5pDDy/xNdf0k3i+wz42zGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)