UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'owCNWZY1JKkE0gWIPshFvT9sRLzdXHyp6KBgwYq5prw='
WHERE
key_id = '024fd52f0cfdf636d5f5eed70807d8a83b00d01bd3a240d0d140ce5dd4c6d92a'
AND (
token = 'owCNWZY1JKkE0gWIPshFvT9sRLzdXHyp6KBgwYq5prw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)