UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H37k4z3oagCXEQkYsVr0SE7HfCqPuhjX0hpnO1UjSKM='
WHERE
key_id = '7a06a544c99c19fff29b38a8d8095bedbd31285836aed25b52ee26fdc52d5287'
AND (
token = 'H37k4z3oagCXEQkYsVr0SE7HfCqPuhjX0hpnO1UjSKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)