UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R06Oym1qLTpgiced+4uc1/qnLTTfgFjuz8qM/EJDSGk='
WHERE
key_id = 'f5a8af21874549fd8b1ac6bd75e3322d6e20a52511542f7849f5381af9604059'
AND (
token = 'R06Oym1qLTpgiced+4uc1/qnLTTfgFjuz8qM/EJDSGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)