UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wSAmsQlJHf2LSws7xLIi9NbE8+YVLHVzOSuKkDy+NGk='
WHERE
key_id = '30e1a0f492c405492def6ab440f777de2b6e31303ef10f86f54fa5faf4bcc97a'
AND (
token = 'wSAmsQlJHf2LSws7xLIi9NbE8+YVLHVzOSuKkDy+NGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)