UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hmlTzgwHRN3M1wFFzVWzMKHjpTYCBA26IxX0pvGcT4A='
WHERE
key_id = 'add1c20446c16579bb54cfff9400c22eb95bf2500a5852f2bf5591f0f6d34565'
AND (
token = 'hmlTzgwHRN3M1wFFzVWzMKHjpTYCBA26IxX0pvGcT4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)