UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIRJuOY+esRwIm473MNISNbYrZdhK+CANOGGUmyZOhg='
WHERE
key_id = 'fae0d9f059c48d400c63db4e4fd3cfe0742c7862ecaec109d2d671bd516a18a5'
AND (
token = 'BIRJuOY+esRwIm473MNISNbYrZdhK+CANOGGUmyZOhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)