UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9H4GcfTR8LtaFJO4rvxDq87UI73drIWHXA9gR/McUso='
WHERE
key_id = 'a16ed8352bc2367911a72e46d39745f11ad694187f9003dc0d551df2313b08fa'
AND (
token = '9H4GcfTR8LtaFJO4rvxDq87UI73drIWHXA9gR/McUso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)