UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OJcHtpsuKQC28fHoSOna7xthOSvcf/G9UTQIojdj9Kg='
WHERE
key_id = '3024e926b98831fe33dc8b3fd0a0667625a764dec9bc28db8d87b4ca3cb7d388'
AND (
token = 'OJcHtpsuKQC28fHoSOna7xthOSvcf/G9UTQIojdj9Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)