UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Tnctd1GyvcMaTd4KOPQhPUUpZdJgf1CM4VkBiNcufA='
WHERE
key_id = '12d0a153b2d36ebbf2212cd4334343ad31d20c094294ff4576b2bcd3d77e2ae3'
AND (
token = '+Tnctd1GyvcMaTd4KOPQhPUUpZdJgf1CM4VkBiNcufA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)