UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BoLGbsSGZDggMyLeBgIvk+f04fQYPu7+Ywqy2K9yQOk='
WHERE
key_id = '7723031b7e7c4dab9b98d00ba4cef7ffaacadda727f44492b0183ff907de15a9'
AND (
token = 'BoLGbsSGZDggMyLeBgIvk+f04fQYPu7+Ywqy2K9yQOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)