UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'buy1ZJNRaS4yqcLSNZ/KAhgyxioMuWDRTkuAUdhIzAU='
WHERE
key_id = 'ab072ae37bb6002e657cf4368c84e31f871f4ac29b96e452939c5ff5c25297fa'
AND (
token = 'buy1ZJNRaS4yqcLSNZ/KAhgyxioMuWDRTkuAUdhIzAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)