UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPtp6X6NnQpB2nrLuuYqRjRk1SIAK5QE/gThm2EYNR8='
WHERE
key_id = 'a05be3bbd4f0cde9bc88a386b1b79b1513d911414bd881af5dc06bedbbaf99bc'
AND (
token = 'qPtp6X6NnQpB2nrLuuYqRjRk1SIAK5QE/gThm2EYNR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)