UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tz1nqK2YEdtB/vf5pauklY975fuOwVtqbjQIQkxybM='
WHERE
key_id = 'a0abbd9d086282acb7c9a26fcab235e778219f140926b9a37a913046e64a6841'
AND (
token = '1tz1nqK2YEdtB/vf5pauklY975fuOwVtqbjQIQkxybM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)