UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6A2YjRDuX8I0J6vStt9MCisRnbBm1n7DBje0TuF8uAo='
WHERE
key_id = '6423a6764a08c8643848304d2c1d1d41de83abcd2e8862613923d90b5d210788'
AND (
token = '6A2YjRDuX8I0J6vStt9MCisRnbBm1n7DBje0TuF8uAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)