UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bc8wFCR7Hqpft7iwzLpOgTl6nsKi1VITJ30obgtKwKE='
WHERE
key_id = '9abb94fa33c54ab9e704396f887d0cd931b7791b1b996d1a0ba66845cf4e147e'
AND (
token = 'bc8wFCR7Hqpft7iwzLpOgTl6nsKi1VITJ30obgtKwKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)