UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EmTn4LYmlb02+SpXsgKkG1Xm9w2AX6vTwNCvS4/O98I='
WHERE
key_id = '07e0b3e93477fbc73e319331ac3a91ba0f3300ae4bf9f4193019348bc60b5be0'
AND (
token = 'EmTn4LYmlb02+SpXsgKkG1Xm9w2AX6vTwNCvS4/O98I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)