UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oRfX+A8sbJTPItsse0YHNkouRl5TBYbebxqgydUsEV4='
WHERE
key_id = 'dd1f5f2ff8dab4754f4b68fb4e2545b6cdb128e8d0ef922d486306d67a97fcf4'
AND (
token = 'oRfX+A8sbJTPItsse0YHNkouRl5TBYbebxqgydUsEV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)