UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7H6eoEczOq2xQzKYliXMSHiw4aVsGzaWf81K/MADEew='
WHERE
key_id = '18a3a682c549b0ad169aaa7bb8c35d85af9cde7f61a8f300621f31dc03a1b827'
AND (
token = '7H6eoEczOq2xQzKYliXMSHiw4aVsGzaWf81K/MADEew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)