UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vxeL76tZb5c4vBmxaVoWcEuEZopgSrm0R0AKK2A0WD8='
WHERE
key_id = '96ed833f4faa6882033a19cf84c90f01771b015841cf9d695d2471a8b4330fa1'
AND (
token = 'vxeL76tZb5c4vBmxaVoWcEuEZopgSrm0R0AKK2A0WD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)