UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XpxIi59Kjeu36tPAE3ejbGyTekfRjQjl6i5mFKyZIM='
WHERE
key_id = '67451bdf20044a54c76283e79aa8d8755cdcb6309edd3ad79b89fa0642aca7b2'
AND (
token = '4XpxIi59Kjeu36tPAE3ejbGyTekfRjQjl6i5mFKyZIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)